Release 10.1A: OpenEdge Data Management:
Database Administration

I/O Operations By Type

Displays information about I/O activity, organized by type. Figure 19–38 shows a sample I/O Operations by Type Activity display.

09/25/03             Activity: I/O Operations by Type 16:31               from 09/25/03 15:31 to 09/25/03 16:04                                     Total   Per Min   Per Sec    Per Tx Database reads                      57      0         0.03       0.04   Index blocks                      13      0         0.00       0.01   Data blocks                       44      0         0.02       0.03 BI reads                            13      0         0.00       0.00 AI Reads                            0       0         0.00       0.05 Total reads                         70      0         0.04       0.05 Database writes                     3       0         0.00       0.00   Index blocks                      0       0         0.00       0.00   Data blocks                       3       0         0.08       0.00 BI writes                           131     0         0.00       0.10 AI writes                           0       0         0.00       0.00 Total writes                        134     0         0.08       0.11

Figure 19–38: PROMON I/O Operations by Type Activity display

The display lists the following types of I/O operations:

Database reads — Total number of reads from the database:
Index blocks — The number of reads of index blocks.
Data blocks — The number of reads of data blocks.
BI reads — The number of blocks read from BI files.
AI reads — The number of blocks read from AI files.
Total reads — Total number of database, BI, and AI read operations.
Database writes — Total number of writes to the database:
Index blocks — The number of writes of index blocks.
Data blocks — The number of writes of data blocks.
BI writes — The number of BI write operations.
AI writes — The number of AI write operations.
Total writes — Total number of database, BI, and AI write operations.